const Goods = require('../model/goods.model')

class GoodsService{
  async createGoods(goods){
  const res =  await Goods.create(goods)
  return res.dataValues
  }
  async updateGoods(id, goods){
    const res = await Goods.update(goods,{where: {id:id}})
    return res[0] > 0 ? true : false;
  }
  async removeGoods(id){
   const res =  await Goods.destroy({where: {id}})
   return res > 0 ? true : false;
  }
  async restoreGoods(id){
    const res =  await Goods.restore({where: {id}})
   return res > 0 ? true : false;
  }
  async findGoods(pageNum,pageSize){
    // // 1,获取总数
    // const count = await Goods.count()
    // //2，获取分页的具体数据
    // const offset = (pageNum -1) * pageSize
    // const rows = await Goods.findAll({offset,limit:pageSize * 1})
    // 优化上面代码
    const offset = (pageNum -1) * pageSize
    const {count,rows} = await Goods.findAndCountAll({
      attributes:['id','goods_name','goods_price','goods_num','goods_img'],
      offset,
      limit:pageSize * 1
    })
    return {
      pageNum,
      pageSize,
      total:count,
      list:rows
    }
  }
}

module.exports = new GoodsService()